package com.dameng.work.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

/**
 * @author xgt(小光头)
 * @version 1.0
 * @date 2022-1-9 22:14
 * CREATE TABLE "SYSDBA"."DM_GOODS"
 * (
 * "ID" INT IDENTITY(1, 1) NOT NULL,
 * "GOOD_ID" VARCHAR(50),
 * "NAME" VARCHAR(4000),
 * "PRICE" NUMBER(22,2),
 * "GOOD_DESC" TEXT,
 * "BRAND_ID" INT,
 * "BRAND_UUID" VARCHAR(50),
 * "CATEGORY_ID" INT,
 * "SELLER_ID" INT,
 * "SELLER_UUID" VARCHAR(50),
 * "IS_DELETE" CHAR(10),
 * "CREATE_TIME" DATE DEFAULT CURDATE(),
 * NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;
 *
 * COMMENT ON TABLE "SYSDBA"."DM_GOODS" IS '商品表';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."ID" IS '商品编号';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."GOOD_ID" IS '生成UUID';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."NAME" IS '商品标题';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."PRICE" IS '商品价格';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."GOOD_DESC" IS '商品的描述';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."BRAND_ID" IS '商品品牌编号';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."CATEGORY_ID" IS '商品的类型';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."SELLER_ID" IS '商家ID编号';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."SELLER_UUID" IS '商家UUID';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."IS_DELETE" IS '是否删除（1：已经删除 0：未删除）';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."CREATE_TIME" IS '创建时间';
 * COMMENT ON COLUMN "SYSDBA"."DM_GOODS"."BRAND_UUID" IS '商品品牌编号(UUID)';
 */
@Data
@TableName("DM_GOODS")
public class GOOD {

    @TableId(type = IdType.AUTO)
    private Integer ID;

    private String GOOD_ID;
    private String NAME;
    private BigDecimal PRICE;
    private String GOOD_DESC;

    private Integer BRAND_ID;
    private String BRAND_UUID;

//    商品的类型 暂定1
    private Integer CATEGORY_ID;

    private Integer SELLER_ID;
    private String SELLER_UUID;

    private Integer IS_DELETE;

    private Date CREATE_TIME;
}
